UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aIYk/cI67N/UC9XoaWss+JLhqY/6aLhN692dUQ5P/V4='
WHERE
key_id = 'a4a4b89f51b10a6ea592280707e263526ec10f267842b8f40ce3be9a9979247b'
AND (
token = 'aIYk/cI67N/UC9XoaWss+JLhqY/6aLhN692dUQ5P/V4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)