UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VqFq3BEkOySArJ1Ood6iATl3P/Dzz6P7GDQNhhnB/Tk='
WHERE
key_id = 'e31cc93192f981845cfd30cdd42add370684e3a8a9ce1ab691bdb20101d4d99d'
AND (
token = 'VqFq3BEkOySArJ1Ood6iATl3P/Dzz6P7GDQNhhnB/Tk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)