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