UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3GqJCkNo7Ml82Lx5AQvA10Cb8uhTO1jdXszVZR9PwRc='
WHERE
key_id = '2c02bf67c56382b781cd5b972858313e933ba01ae833d5b0ec629b403252d74f'
AND (
token = '3GqJCkNo7Ml82Lx5AQvA10Cb8uhTO1jdXszVZR9PwRc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)