UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7QBuYSBh75W/jWRLZ5HE/5N8qlUN5Nq5zkDpdEbVe5Y='
WHERE
key_id = 'efd1bd275e47c485542f2e76ba4a2d3d934890ed20938f6296661571d485fd64'
AND (
token = '7QBuYSBh75W/jWRLZ5HE/5N8qlUN5Nq5zkDpdEbVe5Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)