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