UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VIyc8XnvRphrkHOfnJFreSkzsb44gt7gsslsfNKpK9o='
WHERE
key_id = '23fc1c14265804c7bb6232f412cc83e65c4cc2bebf09139b2da421e66c1ba2ab'
AND (
token = 'VIyc8XnvRphrkHOfnJFreSkzsb44gt7gsslsfNKpK9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)