UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CEJmeDxuA7eBG1ERcYAx38nd7tSKDmOuCKvOYBaiHT8='
WHERE
key_id = 'b59e271e979da5fd58a37799dfc22b710c0c884016551b2978260dc506e24a58'
AND (
token = 'CEJmeDxuA7eBG1ERcYAx38nd7tSKDmOuCKvOYBaiHT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)