UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hfMtSf8vHKr2FMLONNAxwhZTg6HruT8ZzvKj6rKifKo='
WHERE
key_id = '0303d4c3a382b48b81132d3b3f7b76cc48972598998993f542d1413042f272ef'
AND (
token = 'hfMtSf8vHKr2FMLONNAxwhZTg6HruT8ZzvKj6rKifKo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)