UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mzf/0nioBOEH2aA5jaMFUuq4Ez9gqIcqmHTx+wXRnLw='
WHERE
key_id = '3ee138f423af9a2b8430a0519500660c8f46309573ccc4420792b4640bcf4671'
AND (
token = 'mzf/0nioBOEH2aA5jaMFUuq4Ez9gqIcqmHTx+wXRnLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)