UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9UYhVxTn67eCK4buT1DCDiqFz0Gz4QGBoox2/7D1fZw='
WHERE
key_id = 'fdc4f61ad21dedcd829a64ffdfcb1da38df9318645aa9cfec5720d72015a5680'
AND (
token = '9UYhVxTn67eCK4buT1DCDiqFz0Gz4QGBoox2/7D1fZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)