UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hUpCwNAJYYJiy/KgU9UglCka7o16l/UTFKjVBcgQv1k='
WHERE
key_id = '512c47a0a0f17f7ce648188e3db23763ac30c5a097161e23cc15d2a3e2f1642a'
AND (
token = 'hUpCwNAJYYJiy/KgU9UglCka7o16l/UTFKjVBcgQv1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)