UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ir25Y8HTTNzR8CYVe8BL0m2Wu9fecc4yprJSN2dasoM='
WHERE
key_id = 'f1d5b19685f08f61a1adef4804e68a28b07bebe3ef8a20d15e50d45173ef9d29'
AND (
token = 'Ir25Y8HTTNzR8CYVe8BL0m2Wu9fecc4yprJSN2dasoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)