UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CqCBI1AeTeGj+dzx6WSuE09lWD9PtQCOF+M2FJO4VdQ='
WHERE
key_id = 'd9950b53e3063e6ae160e15cf0a248cfc1b06a00eb13997e9341ee06d5d22a2f'
AND (
token = 'CqCBI1AeTeGj+dzx6WSuE09lWD9PtQCOF+M2FJO4VdQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)