UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w9noSot9Ijl7nzNf+5rysSVeMp84uSOUTiqm5Td+TYw='
WHERE
key_id = '37bca36590c550c96dd84ff690bcf9fd448e4cb77fa12eb1e5022b263a1a26ae'
AND (
token = 'w9noSot9Ijl7nzNf+5rysSVeMp84uSOUTiqm5Td+TYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)