UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9qLRxe2IAPEr84ZnXB3Q3OXaCWja6NKJIRywhtLCIM4='
WHERE
key_id = 'b11ac65fa729b880fc35f0d23af07b8b38fb27da4ec1b5e1dde21f8a5d6ae295'
AND (
token = '9qLRxe2IAPEr84ZnXB3Q3OXaCWja6NKJIRywhtLCIM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)