UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bsu31UFANC63Y9xakcnl6wtPmbLO0B9k1yFW6tYXH08='
WHERE
key_id = '7ab6267a539f66084c2a8b000bfb545d59be636fdadc47ed85bbf8be81f1f2b3'
AND (
token = 'Bsu31UFANC63Y9xakcnl6wtPmbLO0B9k1yFW6tYXH08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)