UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oDmSTaqWgAIncZTKqNBrkV0jbF/cRA+uETw/aFYW2/4='
WHERE
key_id = 'f23a26c207ed6567360ecddf14fc2d14a503b0a7fa02dc0b68953374a6be0e25'
AND (
token = 'oDmSTaqWgAIncZTKqNBrkV0jbF/cRA+uETw/aFYW2/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)