UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0f66SmMyvJqqagzuI8Oj/1XfPSmB9fbQy1caQXNjpHw='
WHERE
key_id = '02a3c0ea06f571ef9cad30bef4e95b29a0e22818754f282219be5142f32e89f5'
AND (
token = '0f66SmMyvJqqagzuI8Oj/1XfPSmB9fbQy1caQXNjpHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)