UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pQAMWpSstBsbK+J4eBwL0AJjcEQG41GrqfjKcLtD8tY='
WHERE
key_id = '6167f0ed285981a70303c367afd0db16fc6f75698c46d7273a3884280244f4b8'
AND (
token = 'pQAMWpSstBsbK+J4eBwL0AJjcEQG41GrqfjKcLtD8tY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)