UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sgXMxoW1m0v9rUBmA4vTktnYx4VW/gDeoeC/oNIHuCA='
WHERE
key_id = 'c447e4427f10744b999a89757f774a0e885577f01f5383d93c03806a0bd4a7ed'
AND (
token = 'sgXMxoW1m0v9rUBmA4vTktnYx4VW/gDeoeC/oNIHuCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)