UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ImCp9IkEvQfjMvGQfYpikGrnZ49j92ctk2zSB1u0TLI='
WHERE
key_id = '787d83529fc0e5bea409b0d31763c4303e98e74cb599d4c0a614de87d981ddec'
AND (
token = 'ImCp9IkEvQfjMvGQfYpikGrnZ49j92ctk2zSB1u0TLI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)