UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Iv27FH6VmZZZ0kOh7sJen5tWgA2xdb3i0UYY57Uubh8='
WHERE
key_id = '9c501d4fd5019bca1976447a82862ced2cf72622bb611560c04cf99945426b14'
AND (
token = 'Iv27FH6VmZZZ0kOh7sJen5tWgA2xdb3i0UYY57Uubh8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)