UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Lg9Id12dxDmZx31K/qFjhIuYg8C/S18yqszoC5hJtc='
WHERE
key_id = 'ef0d1355f878f9a88bfe7a372790bd8b89c0fc354ddc4218bb7fa49c14c9de39'
AND (
token = '5Lg9Id12dxDmZx31K/qFjhIuYg8C/S18yqszoC5hJtc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)