UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OzKDI1CmYa0m4VlXDtznYaGRV+lSrKnST7BRivb+yKo='
WHERE
key_id = 'e671c523ff4368c03dd071ee5313f95468ec7a36b02f6750bbe8f0d7141d22ff'
AND (
token = 'OzKDI1CmYa0m4VlXDtznYaGRV+lSrKnST7BRivb+yKo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)