UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sMqAhfva19JNsQunt6ZQMdExcDX5yEzRwi98SObUQng='
WHERE
key_id = 'b0c830afe01234c0c31442ba7d093a92a58e755665a2bc9b289f9d6ae78d6bd5'
AND (
token = 'sMqAhfva19JNsQunt6ZQMdExcDX5yEzRwi98SObUQng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)