UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQxUqLMDOSd8nXlFLLxi4uBrtXM5krCR8mn9/fIMhhU='
WHERE
key_id = '49446dc3c0b55c25ed00c458a3c2236c1a2fb315d4cd1a2a2dacddfe0198325b'
AND (
token = 'zQxUqLMDOSd8nXlFLLxi4uBrtXM5krCR8mn9/fIMhhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)