UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Au9Csf/Jz3zqmof59Ar1CjcDnc1KNg+oexylIu+I/v8='
WHERE
key_id = '78367760d478d65debef64e10cd869cb961d358f73294989c6a86451852d2b36'
AND (
token = 'Au9Csf/Jz3zqmof59Ar1CjcDnc1KNg+oexylIu+I/v8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)