UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nKkCCoS/FdKF3Og/OO83Dus9TZeCunKHfKkywnrJqn8='
WHERE
key_id = 'afb862489744adea7081a7ef59addffadea1e9432ecc8dfde46e127dc118c47b'
AND (
token = 'nKkCCoS/FdKF3Og/OO83Dus9TZeCunKHfKkywnrJqn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)