UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '89fAUj4ZT6trlcLVhAP77ycI3i6xlo3eFhTdG22MwmA='
WHERE
key_id = 'dd7e1799ebdadf061843e650042c3b3095abcec41035e827a16bdf14899706ff'
AND (
token = '89fAUj4ZT6trlcLVhAP77ycI3i6xlo3eFhTdG22MwmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)