UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dfEuJFe0MEq8iZwiVseqWojpE5dhRc579XPlrrzkLR8='
WHERE
key_id = '8b60172606ea4e3795e0169418b922327c662811b153fe0ebf151b0e374e0928'
AND (
token = 'dfEuJFe0MEq8iZwiVseqWojpE5dhRc579XPlrrzkLR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)