UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5u8ERx4yZiZgpwwjmjtjjfkFUViNgCWvWRTF48aoRhY='
WHERE
key_id = 'b1ef43d52c7b189d00a6619b5cdea18656619fa8fe66cf6d6e1c96980c15e053'
AND (
token = '5u8ERx4yZiZgpwwjmjtjjfkFUViNgCWvWRTF48aoRhY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)