UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4qcBFxUEdu/HsKzXm1uMPIr0qsCoe7Zc6dj3intBjfw='
WHERE
key_id = 'a803e158b7df71bc3db75d49b498105655bcf59e3d0b8c44c872e25ee226e212'
AND (
token = '4qcBFxUEdu/HsKzXm1uMPIr0qsCoe7Zc6dj3intBjfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)