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