UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Zo0ovW3UsuWk7IYarKQKg9KiX3JIpQjEGQA6cQv9zw='
WHERE
key_id = '7ec69d6ecd3337e783e54e529ea165f17c07dddf464bc1128aa63dc2f92ce037'
AND (
token = '0Zo0ovW3UsuWk7IYarKQKg9KiX3JIpQjEGQA6cQv9zw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)