UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jl/c4Yhw0F8Yc7q8syrdUuax0UkMH3pddStACCEFlJo='
WHERE
key_id = 'c380c9ddc6173831199fd0d59a5cd1dd7ade5b1afa622530063190b78086b022'
AND (
token = 'Jl/c4Yhw0F8Yc7q8syrdUuax0UkMH3pddStACCEFlJo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)